﻿using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;
using System.Web.DynamicData;
using System.Data.SqlClient;

namespace sistemaAcademicoFinanceiroEscolasdisciplina
{
    public partial class List : System.Web.UI.Page
    {
        protected MetaTable table;

        protected void Page_Init(object sender, EventArgs e)
        {
            DynamicDataManager1.RegisterControl(GridView1, true /*setSelectionFromUrl*/);
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            table = GridDataSource.GetTable();
            Title = table.DisplayName;

            //InsertHyperLink.NavigateUrl = table.GetActionPath(PageAction.Insert);

            // Disable various options if the table is readonly
            if (table.IsReadOnly)
            {
                GridView1.Columns[0].Visible = false;
                //InsertHyperLink.Visible = false;
            }

            DynamicFilterForm1.Focus();

        }

        protected void OnFilterSelectedIndexChanged(object sender, EventArgs e)
        {
            GridView1.PageIndex = 0;
        }

        protected void RowDataBound(object sender, GridViewRowEventArgs e)
        {

            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                sistemaAcademicoFinanceiroEscolas.disciplina dc = (sistemaAcademicoFinanceiroEscolas.disciplina)e.Row.DataItem;

                string codigoDisciplina = dc.codigoDisciplina.ToString();

                //localizar professores da disciplina

                string sqlDisciplina = "SELECT disciplinaProfessor.codigoDisciplina, professor.codigoProfessor, professor.nomeProfessor ";
                sqlDisciplina = sqlDisciplina + "FROM disciplina INNER JOIN disciplinaProfessor ON disciplina.codigoDisciplina = ";
                sqlDisciplina = sqlDisciplina + "disciplinaProfessor.codigoDisciplina INNER JOIN ";
                sqlDisciplina = sqlDisciplina + "professor ON disciplinaProfessor.codigoProfessor = professor.codigoProfessor ";
                sqlDisciplina = sqlDisciplina + "WHERE (disciplinaProfessor.codigoDisciplina = " + codigoDisciplina + ")";

                SqlConnection sqlc = new SqlConnection(ConfigurationManager.AppSettings["baseDados"]);
                sqlc.Open();

                SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sqlDisciplina, sqlc);
                SqlDataReader myReader = cmd.ExecuteReader();


                while (myReader.Read())
                {

                    string literal = myReader["nomeProfessor"].ToString() + "<br>";
                    e.Row.Cells[2].Controls.Add(new LiteralControl(literal));

                }

                cmd.Dispose();
                myReader.Close();
                sqlc.Close();


            }

        }
    }
}
